SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Aurelio and Miranda"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: The Children in the Wood

Song: Mainpiece: Chorusses-Danby, Wentworth, Brown, Tett, Denman, Atkins, [J.] Fisher, Aylmer, Gallot, Peck, Walker, Willoughby, Phillimore, Evans, Fisher, Caulfield Jun., Ms Arne, Ms Roffey, Ms Wentworth, Ms Jackson, Ms Maddocks, Ms Menage, Ms Menage Jun., Ms Chippendale, Ms Gawdry, Ms Butler, Ms Benson, Ms Bowyer, Ms Jacobs, Ms Coates

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: Chorusses, as17981229, but _Tett, _Denman, _Atkins, _Aylmer, _Gallot, _Peck, _Walker, _Willoughby, _Phillimore, _Caulfield Jun

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: The Prize

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231